package com.ztesoft.web.common.db.arg;

import java.util.*;
import java.math.*;
import org.apache.commons.lang.*;

public class DmDataCommandArg {
    private String pk_name = "COMMAND_ID";

    private String orderByClause;

    private String groupByClause;

    private String columns;

    private String countsql1;

    private String countsql2;

    private boolean distinct;

    private int rowStart = 0;

    private int rowEnd = 10;

    private List<DmDataCommandCriteria> oredCriteria;

    public DmDataCommandArg() {
        oredCriteria = new ArrayList<DmDataCommandCriteria>();
    }

    public void setPk_name(String pk_name) {
        this.pk_name = StringEscapeUtils.escapeSql(pk_name);
    }

    public String getPk_name() {
        return pk_name;
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = StringEscapeUtils.escapeSql(orderByClause);
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = StringEscapeUtils.escapeSql(groupByClause);
    }

    public String geGroupByClause() {
        return groupByClause;
    }

    public void setColumns(String columns) {
        this.columns = StringEscapeUtils.escapeSql(columns);
    }

    public String geColumns() {
        return columns;
    }

    public void setCountsql1(String countsql1) {
        this.countsql1 = StringEscapeUtils.escapeSql(countsql1);
    }

    public String geCountsql1() {
        return countsql1;
    }

    public void setCountsql2(String countsql2) {
        this.countsql2 = StringEscapeUtils.escapeSql(countsql2);
    }

    public String geCountsql2() {
        return countsql2;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public void setRowStart(int rowStart) {
        this.rowStart = rowStart;
    }

    public void setRowEnd(int rowEnd) {
        this.rowEnd = rowEnd;
    }

    public int getRowStart() {
        return rowStart;
    }

    public int getRowEnd() {
        return rowEnd;
    }

    public List<DmDataCommandCriteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(DmDataCommandCriteria criteria) {
        oredCriteria.add(criteria);
    }

    public DmDataCommandCriteria or() {
    	DmDataCommandCriteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public DmDataCommandCriteria createCriteria() {
    	DmDataCommandCriteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected DmDataCommandCriteria createCriteriaInternal() {
    	DmDataCommandCriteria criteria = new DmDataCommandCriteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        groupByClause = null;
        columns = null;
        countsql1 = null;
        countsql2 = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<DmDataCommandCriterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<DmDataCommandCriterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<DmDataCommandCriterion> getAllCriteria() {
            return criteria;
        }

        public List<DmDataCommandCriterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new DmDataCommandCriterion(condition));
        }

        protected void addCriterion(String condition, Object value,
                String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new DmDataCommandCriterion(condition, value));
        }

        protected void addCriterion(String condition, Object value,
                String property, int likeType) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new DmDataCommandCriterion(condition, value, likeType));
        }

        protected void addCriterion(String condition, Object value1,
                Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property
                        + " cannot be null");
            }
            criteria.add(new DmDataCommandCriterion(condition, value1, value2));
        }

        public DmDataCommandCriteria andCriterionEqualTo(String criterion) {
            if (StringUtils.isBlank(criterion)) {
                criterion = "1=1";
            }
            addCriterion(criterion);
            return (DmDataCommandCriteria) this;
        }
        public DmDataCommandCriteria andCommandIdIsNull() {
            addCriterion("COMMAND_ID is null");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandIdIsNotNull() {
            addCriterion("COMMAND_ID is not null");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandIdEqualTo(Integer value) {
            addCriterion("COMMAND_ID =", value, "COMMAND_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandIdNotEqualTo(Integer value) {
            addCriterion("COMMAND_ID <>", value, "COMMAND_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandIdGreaterThan(Integer value) {
            addCriterion("COMMAND_ID >", value, "COMMAND_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("COMMAND_ID >=", value, "COMMAND_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandIdLessThan(Integer value) {
            addCriterion("COMMAND_ID <", value, "COMMAND_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandIdLessThanOrEqualTo(Integer value) {
            addCriterion("COMMAND_ID <=", value, "COMMAND_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandIdLike(Integer value) {
            addCriterion("COMMAND_ID like ", value, "COMMAND_ID", 1);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandIdNotLike(Integer value) {
            addCriterion("COMMAND_ID  not like ", value, "COMMAND_ID", 1);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandIdLeftLike(Integer value) {
            addCriterion("COMMAND_ID like ", value, "COMMAND_ID", 0);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandIdNotLeftLike(Integer value) {
            addCriterion("COMMAND_ID  not like ", value, "COMMAND_ID", 0);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandIdRightLike(Integer value) {
            addCriterion("COMMAND_ID like ", value, "COMMAND_ID", 2);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandIdNotRightLike(Integer value) {
            addCriterion("COMMAND_ID  not like ", value, "COMMAND_ID", 2);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandIdIn(List<Integer> values) {
            addCriterion("COMMAND_ID  in ", values, "COMMAND_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandIdNotIn(List<Integer> values) {
            addCriterion("COMMAND_ID not in ", values, "COMMAND_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandIdBetween(Integer value1, Integer value2) {
            addCriterion("COMMAND_ID between ", value1, value2, "COMMAND_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandIdNotBetween(Integer value1, Integer value2) {
            addCriterion("COMMAND_ID not between ", value1, value2, "COMMAND_ID");
            return (DmDataCommandCriteria) this;
        }
        public DmDataCommandCriteria andSourceDataIdIsNull() {
            addCriterion("SOURCE_DATA_ID is null");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andSourceDataIdIsNotNull() {
            addCriterion("SOURCE_DATA_ID is not null");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andSourceDataIdEqualTo(Integer value) {
            addCriterion("SOURCE_DATA_ID =", value, "SOURCE_DATA_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andSourceDataIdNotEqualTo(Integer value) {
            addCriterion("SOURCE_DATA_ID <>", value, "SOURCE_DATA_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andSourceDataIdGreaterThan(Integer value) {
            addCriterion("SOURCE_DATA_ID >", value, "SOURCE_DATA_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andSourceDataIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("SOURCE_DATA_ID >=", value, "SOURCE_DATA_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andSourceDataIdLessThan(Integer value) {
            addCriterion("SOURCE_DATA_ID <", value, "SOURCE_DATA_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andSourceDataIdLessThanOrEqualTo(Integer value) {
            addCriterion("SOURCE_DATA_ID <=", value, "SOURCE_DATA_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andSourceDataIdLike(Integer value) {
            addCriterion("SOURCE_DATA_ID like ", value, "SOURCE_DATA_ID", 1);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andSourceDataIdNotLike(Integer value) {
            addCriterion("SOURCE_DATA_ID  not like ", value, "SOURCE_DATA_ID", 1);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andSourceDataIdLeftLike(Integer value) {
            addCriterion("SOURCE_DATA_ID like ", value, "SOURCE_DATA_ID", 0);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andSourceDataIdNotLeftLike(Integer value) {
            addCriterion("SOURCE_DATA_ID  not like ", value, "SOURCE_DATA_ID", 0);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andSourceDataIdRightLike(Integer value) {
            addCriterion("SOURCE_DATA_ID like ", value, "SOURCE_DATA_ID", 2);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andSourceDataIdNotRightLike(Integer value) {
            addCriterion("SOURCE_DATA_ID  not like ", value, "SOURCE_DATA_ID", 2);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andSourceDataIdIn(List<Integer> values) {
            addCriterion("SOURCE_DATA_ID  in ", values, "SOURCE_DATA_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andSourceDataIdNotIn(List<Integer> values) {
            addCriterion("SOURCE_DATA_ID not in ", values, "SOURCE_DATA_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andSourceDataIdBetween(Integer value1, Integer value2) {
            addCriterion("SOURCE_DATA_ID between ", value1, value2, "SOURCE_DATA_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andSourceDataIdNotBetween(Integer value1, Integer value2) {
            addCriterion("SOURCE_DATA_ID not between ", value1, value2, "SOURCE_DATA_ID");
            return (DmDataCommandCriteria) this;
        }
        public DmDataCommandCriteria andDbLinkIdIsNull() {
            addCriterion("DB_LINK_ID is null");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andDbLinkIdIsNotNull() {
            addCriterion("DB_LINK_ID is not null");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andDbLinkIdEqualTo(Integer value) {
            addCriterion("DB_LINK_ID =", value, "DB_LINK_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andDbLinkIdNotEqualTo(Integer value) {
            addCriterion("DB_LINK_ID <>", value, "DB_LINK_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andDbLinkIdGreaterThan(Integer value) {
            addCriterion("DB_LINK_ID >", value, "DB_LINK_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andDbLinkIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("DB_LINK_ID >=", value, "DB_LINK_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andDbLinkIdLessThan(Integer value) {
            addCriterion("DB_LINK_ID <", value, "DB_LINK_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andDbLinkIdLessThanOrEqualTo(Integer value) {
            addCriterion("DB_LINK_ID <=", value, "DB_LINK_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andDbLinkIdLike(Integer value) {
            addCriterion("DB_LINK_ID like ", value, "DB_LINK_ID", 1);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andDbLinkIdNotLike(Integer value) {
            addCriterion("DB_LINK_ID  not like ", value, "DB_LINK_ID", 1);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andDbLinkIdLeftLike(Integer value) {
            addCriterion("DB_LINK_ID like ", value, "DB_LINK_ID", 0);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andDbLinkIdNotLeftLike(Integer value) {
            addCriterion("DB_LINK_ID  not like ", value, "DB_LINK_ID", 0);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andDbLinkIdRightLike(Integer value) {
            addCriterion("DB_LINK_ID like ", value, "DB_LINK_ID", 2);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andDbLinkIdNotRightLike(Integer value) {
            addCriterion("DB_LINK_ID  not like ", value, "DB_LINK_ID", 2);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andDbLinkIdIn(List<Integer> values) {
            addCriterion("DB_LINK_ID  in ", values, "DB_LINK_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andDbLinkIdNotIn(List<Integer> values) {
            addCriterion("DB_LINK_ID not in ", values, "DB_LINK_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andDbLinkIdBetween(Integer value1, Integer value2) {
            addCriterion("DB_LINK_ID between ", value1, value2, "DB_LINK_ID");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andDbLinkIdNotBetween(Integer value1, Integer value2) {
            addCriterion("DB_LINK_ID not between ", value1, value2, "DB_LINK_ID");
            return (DmDataCommandCriteria) this;
        }
        public DmDataCommandCriteria andAliasLinkNameIsNull() {
            addCriterion("ALIAS_LINK_NAME is null");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andAliasLinkNameIsNotNull() {
            addCriterion("ALIAS_LINK_NAME is not null");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andAliasLinkNameEqualTo(String value) {
            addCriterion("ALIAS_LINK_NAME =", value, "ALIAS_LINK_NAME");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andAliasLinkNameNotEqualTo(String value) {
            addCriterion("ALIAS_LINK_NAME <>", value, "ALIAS_LINK_NAME");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andAliasLinkNameGreaterThan(String value) {
            addCriterion("ALIAS_LINK_NAME >", value, "ALIAS_LINK_NAME");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andAliasLinkNameGreaterThanOrEqualTo(String value) {
            addCriterion("ALIAS_LINK_NAME >=", value, "ALIAS_LINK_NAME");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andAliasLinkNameLessThan(String value) {
            addCriterion("ALIAS_LINK_NAME <", value, "ALIAS_LINK_NAME");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andAliasLinkNameLessThanOrEqualTo(String value) {
            addCriterion("ALIAS_LINK_NAME <=", value, "ALIAS_LINK_NAME");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andAliasLinkNameLike(String value) {
            addCriterion("ALIAS_LINK_NAME like ", value, "ALIAS_LINK_NAME", 1);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andAliasLinkNameNotLike(String value) {
            addCriterion("ALIAS_LINK_NAME  not like ", value, "ALIAS_LINK_NAME", 1);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andAliasLinkNameLeftLike(String value) {
            addCriterion("ALIAS_LINK_NAME like ", value, "ALIAS_LINK_NAME", 0);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andAliasLinkNameNotLeftLike(String value) {
            addCriterion("ALIAS_LINK_NAME  not like ", value, "ALIAS_LINK_NAME", 0);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andAliasLinkNameRightLike(String value) {
            addCriterion("ALIAS_LINK_NAME like ", value, "ALIAS_LINK_NAME", 2);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andAliasLinkNameNotRightLike(String value) {
            addCriterion("ALIAS_LINK_NAME  not like ", value, "ALIAS_LINK_NAME", 2);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andAliasLinkNameIn(List<String> values) {
            addCriterion("ALIAS_LINK_NAME  in ", values, "ALIAS_LINK_NAME");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andAliasLinkNameNotIn(List<String> values) {
            addCriterion("ALIAS_LINK_NAME not in ", values, "ALIAS_LINK_NAME");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andAliasLinkNameBetween(String value1, String value2) {
            addCriterion("ALIAS_LINK_NAME between ", value1, value2, "ALIAS_LINK_NAME");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andAliasLinkNameNotBetween(String value1, String value2) {
            addCriterion("ALIAS_LINK_NAME not between ", value1, value2, "ALIAS_LINK_NAME");
            return (DmDataCommandCriteria) this;
        }
        public DmDataCommandCriteria andCommandTypeIsNull() {
            addCriterion("COMMAND_TYPE is null");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandTypeIsNotNull() {
            addCriterion("COMMAND_TYPE is not null");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandTypeEqualTo(Integer value) {
            addCriterion("COMMAND_TYPE =", value, "COMMAND_TYPE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandTypeNotEqualTo(Integer value) {
            addCriterion("COMMAND_TYPE <>", value, "COMMAND_TYPE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandTypeGreaterThan(Integer value) {
            addCriterion("COMMAND_TYPE >", value, "COMMAND_TYPE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("COMMAND_TYPE >=", value, "COMMAND_TYPE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandTypeLessThan(Integer value) {
            addCriterion("COMMAND_TYPE <", value, "COMMAND_TYPE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandTypeLessThanOrEqualTo(Integer value) {
            addCriterion("COMMAND_TYPE <=", value, "COMMAND_TYPE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandTypeLike(Integer value) {
            addCriterion("COMMAND_TYPE like ", value, "COMMAND_TYPE", 1);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandTypeNotLike(Integer value) {
            addCriterion("COMMAND_TYPE  not like ", value, "COMMAND_TYPE", 1);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandTypeLeftLike(Integer value) {
            addCriterion("COMMAND_TYPE like ", value, "COMMAND_TYPE", 0);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandTypeNotLeftLike(Integer value) {
            addCriterion("COMMAND_TYPE  not like ", value, "COMMAND_TYPE", 0);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandTypeRightLike(Integer value) {
            addCriterion("COMMAND_TYPE like ", value, "COMMAND_TYPE", 2);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandTypeNotRightLike(Integer value) {
            addCriterion("COMMAND_TYPE  not like ", value, "COMMAND_TYPE", 2);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandTypeIn(List<Integer> values) {
            addCriterion("COMMAND_TYPE  in ", values, "COMMAND_TYPE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandTypeNotIn(List<Integer> values) {
            addCriterion("COMMAND_TYPE not in ", values, "COMMAND_TYPE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandTypeBetween(Integer value1, Integer value2) {
            addCriterion("COMMAND_TYPE between ", value1, value2, "COMMAND_TYPE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("COMMAND_TYPE not between ", value1, value2, "COMMAND_TYPE");
            return (DmDataCommandCriteria) this;
        }
        public DmDataCommandCriteria andCommandIsNull() {
            addCriterion("COMMAND is null");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandIsNotNull() {
            addCriterion("COMMAND is not null");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandEqualTo(String value) {
            addCriterion("COMMAND =", value, "COMMAND");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandNotEqualTo(String value) {
            addCriterion("COMMAND <>", value, "COMMAND");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandGreaterThan(String value) {
            addCriterion("COMMAND >", value, "COMMAND");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandGreaterThanOrEqualTo(String value) {
            addCriterion("COMMAND >=", value, "COMMAND");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandLessThan(String value) {
            addCriterion("COMMAND <", value, "COMMAND");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandLessThanOrEqualTo(String value) {
            addCriterion("COMMAND <=", value, "COMMAND");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandLike(String value) {
            addCriterion("COMMAND like ", value, "COMMAND", 1);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandNotLike(String value) {
            addCriterion("COMMAND  not like ", value, "COMMAND", 1);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandLeftLike(String value) {
            addCriterion("COMMAND like ", value, "COMMAND", 0);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandNotLeftLike(String value) {
            addCriterion("COMMAND  not like ", value, "COMMAND", 0);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandRightLike(String value) {
            addCriterion("COMMAND like ", value, "COMMAND", 2);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandNotRightLike(String value) {
            addCriterion("COMMAND  not like ", value, "COMMAND", 2);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandIn(List<String> values) {
            addCriterion("COMMAND  in ", values, "COMMAND");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandNotIn(List<String> values) {
            addCriterion("COMMAND not in ", values, "COMMAND");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandBetween(String value1, String value2) {
            addCriterion("COMMAND between ", value1, value2, "COMMAND");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCommandNotBetween(String value1, String value2) {
            addCriterion("COMMAND not between ", value1, value2, "COMMAND");
            return (DmDataCommandCriteria) this;
        }
        public DmDataCommandCriteria andParamNameIsNull() {
            addCriterion("PARAM_NAME is null");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andParamNameIsNotNull() {
            addCriterion("PARAM_NAME is not null");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andParamNameEqualTo(String value) {
            addCriterion("PARAM_NAME =", value, "PARAM_NAME");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andParamNameNotEqualTo(String value) {
            addCriterion("PARAM_NAME <>", value, "PARAM_NAME");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andParamNameGreaterThan(String value) {
            addCriterion("PARAM_NAME >", value, "PARAM_NAME");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andParamNameGreaterThanOrEqualTo(String value) {
            addCriterion("PARAM_NAME >=", value, "PARAM_NAME");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andParamNameLessThan(String value) {
            addCriterion("PARAM_NAME <", value, "PARAM_NAME");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andParamNameLessThanOrEqualTo(String value) {
            addCriterion("PARAM_NAME <=", value, "PARAM_NAME");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andParamNameLike(String value) {
            addCriterion("PARAM_NAME like ", value, "PARAM_NAME", 1);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andParamNameNotLike(String value) {
            addCriterion("PARAM_NAME  not like ", value, "PARAM_NAME", 1);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andParamNameLeftLike(String value) {
            addCriterion("PARAM_NAME like ", value, "PARAM_NAME", 0);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andParamNameNotLeftLike(String value) {
            addCriterion("PARAM_NAME  not like ", value, "PARAM_NAME", 0);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andParamNameRightLike(String value) {
            addCriterion("PARAM_NAME like ", value, "PARAM_NAME", 2);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andParamNameNotRightLike(String value) {
            addCriterion("PARAM_NAME  not like ", value, "PARAM_NAME", 2);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andParamNameIn(List<String> values) {
            addCriterion("PARAM_NAME  in ", values, "PARAM_NAME");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andParamNameNotIn(List<String> values) {
            addCriterion("PARAM_NAME not in ", values, "PARAM_NAME");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andParamNameBetween(String value1, String value2) {
            addCriterion("PARAM_NAME between ", value1, value2, "PARAM_NAME");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andParamNameNotBetween(String value1, String value2) {
            addCriterion("PARAM_NAME not between ", value1, value2, "PARAM_NAME");
            return (DmDataCommandCriteria) this;
        }
        public DmDataCommandCriteria andStateIsNull() {
            addCriterion("STATE is null");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateIsNotNull() {
            addCriterion("STATE is not null");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateEqualTo(String value) {
            addCriterion("STATE =", value, "STATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateNotEqualTo(String value) {
            addCriterion("STATE <>", value, "STATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateGreaterThan(String value) {
            addCriterion("STATE >", value, "STATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateGreaterThanOrEqualTo(String value) {
            addCriterion("STATE >=", value, "STATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateLessThan(String value) {
            addCriterion("STATE <", value, "STATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateLessThanOrEqualTo(String value) {
            addCriterion("STATE <=", value, "STATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateLike(String value) {
            addCriterion("STATE like ", value, "STATE", 1);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateNotLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 1);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateLeftLike(String value) {
            addCriterion("STATE like ", value, "STATE", 0);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateNotLeftLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 0);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateRightLike(String value) {
            addCriterion("STATE like ", value, "STATE", 2);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateNotRightLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 2);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateIn(List<String> values) {
            addCriterion("STATE  in ", values, "STATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateNotIn(List<String> values) {
            addCriterion("STATE not in ", values, "STATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateBetween(String value1, String value2) {
            addCriterion("STATE between ", value1, value2, "STATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateNotBetween(String value1, String value2) {
            addCriterion("STATE not between ", value1, value2, "STATE");
            return (DmDataCommandCriteria) this;
        }
        public DmDataCommandCriteria andStateDateIsNull() {
            addCriterion("STATE_DATE is null");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateDateIsNotNull() {
            addCriterion("STATE_DATE is not null");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateDateEqualTo(String value) {
            addCriterion("STATE_DATE =", value, "STATE_DATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateDateNotEqualTo(String value) {
            addCriterion("STATE_DATE <>", value, "STATE_DATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateDateGreaterThan(String value) {
            addCriterion("STATE_DATE >", value, "STATE_DATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateDateGreaterThanOrEqualTo(String value) {
            addCriterion("STATE_DATE >=", value, "STATE_DATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateDateLessThan(String value) {
            addCriterion("STATE_DATE <", value, "STATE_DATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateDateLessThanOrEqualTo(String value) {
            addCriterion("STATE_DATE <=", value, "STATE_DATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateDateLike(String value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 1);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateDateNotLike(String value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 1);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateDateLeftLike(String value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 0);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateDateNotLeftLike(String value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 0);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateDateRightLike(String value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 2);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateDateNotRightLike(String value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 2);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateDateIn(List<String> values) {
            addCriterion("STATE_DATE  in ", values, "STATE_DATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateDateNotIn(List<String> values) {
            addCriterion("STATE_DATE not in ", values, "STATE_DATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateDateBetween(String value1, String value2) {
            addCriterion("STATE_DATE between ", value1, value2, "STATE_DATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andStateDateNotBetween(String value1, String value2) {
            addCriterion("STATE_DATE not between ", value1, value2, "STATE_DATE");
            return (DmDataCommandCriteria) this;
        }
        public DmDataCommandCriteria andCreateDateIsNull() {
            addCriterion("CREATE_DATE is null");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCreateDateIsNotNull() {
            addCriterion("CREATE_DATE is not null");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCreateDateEqualTo(String value) {
            addCriterion("CREATE_DATE =", value, "CREATE_DATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCreateDateNotEqualTo(String value) {
            addCriterion("CREATE_DATE <>", value, "CREATE_DATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCreateDateGreaterThan(String value) {
            addCriterion("CREATE_DATE >", value, "CREATE_DATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCreateDateGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_DATE >=", value, "CREATE_DATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCreateDateLessThan(String value) {
            addCriterion("CREATE_DATE <", value, "CREATE_DATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCreateDateLessThanOrEqualTo(String value) {
            addCriterion("CREATE_DATE <=", value, "CREATE_DATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCreateDateLike(String value) {
            addCriterion("CREATE_DATE like ", value, "CREATE_DATE", 1);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCreateDateNotLike(String value) {
            addCriterion("CREATE_DATE  not like ", value, "CREATE_DATE", 1);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCreateDateLeftLike(String value) {
            addCriterion("CREATE_DATE like ", value, "CREATE_DATE", 0);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCreateDateNotLeftLike(String value) {
            addCriterion("CREATE_DATE  not like ", value, "CREATE_DATE", 0);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCreateDateRightLike(String value) {
            addCriterion("CREATE_DATE like ", value, "CREATE_DATE", 2);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCreateDateNotRightLike(String value) {
            addCriterion("CREATE_DATE  not like ", value, "CREATE_DATE", 2);
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCreateDateIn(List<String> values) {
            addCriterion("CREATE_DATE  in ", values, "CREATE_DATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCreateDateNotIn(List<String> values) {
            addCriterion("CREATE_DATE not in ", values, "CREATE_DATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCreateDateBetween(String value1, String value2) {
            addCriterion("CREATE_DATE between ", value1, value2, "CREATE_DATE");
            return (DmDataCommandCriteria) this;
        }

        public DmDataCommandCriteria andCreateDateNotBetween(String value1, String value2) {
            addCriterion("CREATE_DATE not between ", value1, value2, "CREATE_DATE");
            return (DmDataCommandCriteria) this;
        }

    }

    public static class DmDataCommandCriteria extends GeneratedCriteria {

        protected DmDataCommandCriteria() {
            super();
        }
    }

    public static class DmDataCommandCriterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected DmDataCommandCriterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }
        protected DmDataCommandCriterion(String condition, Object value, int likeType) {
            this.condition = condition;
            if (likeType == 0) {
                this.value = "%" + value;
            }
            else if (likeType == 1) {
                this.value = "%" + value + "%";
            }
            else {
                this.value = value + "%";
            }
            this.typeHandler = null;
            this.singleValue = true;

        }

        protected DmDataCommandCriterion(String condition, Object value,
                String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            }
            else {
                this.singleValue = true;
            }
        }

        protected DmDataCommandCriterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected DmDataCommandCriterion(String condition, Object value,
                Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected DmDataCommandCriterion(String condition, Object value,
                Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}